CREATE TABLE [dbo].[User]
(
[Oid] [uniqueidentifier] NOT NULL ROWGUIDCOL,
[StoredPassword] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UserName] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ChangePasswordOnFirstLogon] [bit] NULL,
[IsActive] [bit] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[User] ADD CONSTRAINT [PK_User] PRIMARY KEY CLUSTERED  ([Oid]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[User] WITH NOCHECK ADD CONSTRAINT [FK_User_Oid] FOREIGN KEY ([Oid]) REFERENCES [dbo].[Person] ([Oid]) NOT FOR REPLICATION
GO
